Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
PARTIC_NAME VARCHAR2(4000) Yes null 6 null NO NO NO
CREATED_ON DATE Yes null 7 null YES YES YES
CREATED_ON_FY NUMBER Yes null 8 null YES YES YES
OBJ VARCHAR2(20) Yes null 1 null YES YES YES
FILE_TAGLINE VARCHAR2(400) Yes null 2 null YES YES YES
FILE_ID VARCHAR2(100) Yes null 3 null YES YES YES
FILE_TYPE VARCHAR2(100) Yes null 4 null YES YES YES
ALLEGATION VARCHAR2(4000) Yes null 5 null YES YES YES
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 24-APR-23
LAST_DDL_TIME 05-FEB-25
OWNER QART
VIEW_NAME V_ALL_ALLEGATIONS
TEXT_LENGTH 362
TEXT SELECT      O.OBJ,  FILE_TAGLINE,  FILE_ID,  FILE_TYPE,  ALLEGATION,  OP.SUBJECTS,     CREATED_ON,      CREATED_ON_FY FROM MV_ALL_ALLEGATIONS O LEFT OUTER JOIN (SELECT OBJ,     LISTAGG(PARTIC_OBJ, ';' || chr(10)) WITHIN GROUP( ORDER BY INVOLV_SID ) SUBJECTS     FROM V_OBJ_PARTICIPANTS      WHERE CODE = 'SUBJECT'     GROUP BY OBJ     ) OP ON OP.OBJ = O.OBJ
TEXT_VC SELECT      O.OBJ,  FILE_TAGLINE,  FILE_ID,  FILE_TYPE,  ALLEGATION,  OP.SUBJECTS,     CREATED_ON,      CREATED_ON_FY FROM MV_ALL_ALLEGATIONS O LEFT OUTER JOIN (SELECT OBJ,     LISTAGG(PARTIC_OBJ, ';' || chr(10)) WITHIN GROUP( ORDER BY INVOLV_SID ) SUBJECTS     FROM V_OBJ_PARTICIPANTS      WHERE CODE = 'SUBJECT'     GROUP BY OBJ     ) OP ON OP.OBJ = O.OBJ
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT